Round 1 - Elimination Resume Grilling + SQL:
1️⃣ 2-3 SQL Question, around self join , usage of Ranking functions and one case specific question around Lead/lag window function
2️⃣ Grilled on a problem statement around fuzzy match (Had mentioned on my resume)
Round 2 - Case Study (Elimination):
There were two questions asked:
1️⃣ A basic guess estimate question, Estimate the number of Uber Cars are there in Bengaluru?
2️⃣ Myntra, wants to solve the issue pertaining to fraudulent customer behaviour, list down all the metrics and provide some actionable on solving this issue
⏩ In this question, I approached by first asking information around the different type of fraudulent activities happen from customers on their platform, before jumping onto any solution
⏩ This round also had resume grilling
Round 3 - Hiring Manager:
⏩ Resume Grilling around the projects being mentioned on my resume (Got stuck in explaining one of the ML project I had mentioned in detail)
⏩ Behavioral questions and whether I would be the right fit at Myntra
Round 4 - HR Discussion:
⏩ This was discussion around salary, joining date and what culture to expect at the org, since I had an offer, it became easier to negotiate salary